|
600
|
How can I display the currency only for not empty cells
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Currency") , "ComputedField", "len(%0) ? currency(dbl(%0)) : ''");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
_ObjectCallMethod( items , "AddItem", "0");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(AddItem()) = 8421631");
_ObjectCallMethod( items , "AddItem", "10000.99");
|
|
599
|
Is there a function to display the number of days between two date including the number of hours
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Start") , "Width", 32);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "End");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Duration") , "ComputedField", "((1:=int(0:= (date(%1)-date(%0)))) != 0 ? (=:1 + ' day(s)') : '') + (=:1 ? ' ' : '' ) + ((1:=int(0:=((=:0 - =:1 + 1/24/60/60/2)" +
"*24))) != 0 ? =:1 + ' hour(s) ' : '' ) + ((1:=round((=:0 - =:1)*60)) != 0 ? =:1 + ' min(s)' : '')");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", #1/11/2001#);
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #1/14/2001#");
h = _ObjectCallMethod( items , "AddItem", #2/22/2002 0:00:00 PM#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #3/14/2002 1:00:00 PM#");
h = _ObjectCallMethod( items , "AddItem", #3/13/2003#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #4/11/2003 11:00:00 AM#");
|
|
598
|
Is there a function to display the number of days between two date including the number of hours
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Start");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "End");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Duration") , "ComputedField", "^"D ^" + int(date(%1)-date(%0)) + ^" H ^" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", #1/11/2001#);
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #1/14/2001 11:00:00 PM#");
h = _ObjectCallMethod( items , "AddItem", #2/22/2002 0:00:00 PM#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #3/14/2002 1:00:00 PM#");
h = _ObjectCallMethod( items , "AddItem", #3/13/2003#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #4/11/2003 11:00:00 AM#");
|
|
597
|
How can I display the number of days between two dates
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Start");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "End");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Duration") , "ComputedField", "(date(%1)-date(%0)) + ' days'");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", #1/11/2001#);
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #1/14/2001#");
h = _ObjectCallMethod( items , "AddItem", #2/22/2002#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #3/14/2002#");
h = _ObjectCallMethod( items , "AddItem", #3/13/2003#);
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = #4/11/2003#");
|
|
596
|
How can I get second part of the date
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Second") , "ComputedField", "sec(date(%0))");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:10:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:01:22 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:23:01 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:11:59 PM#);
|
|
595
|
How can I get minute part of the date
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Minute") , "ComputedField", "min(date(%0))");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:10:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:01:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:23:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:11:00 PM#);
|
|
594
|
How can I check the hour part only so I know it was afternoon
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "ConditionalFormats") , "Add", "hour(%0)>=12") , "Bold", -1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Hour") , "ComputedField", "hour(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:00:00 PM#);
|
|
593
|
What about a function to get the day in the week, or days since Sunday
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "WeekDay") , "ComputedField", "weekday(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:00:00 PM#);
|
|
592
|
Is there any function to get the day of the year or number of days since January 1st
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Day since January 1st") , "ComputedField", "yearday(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:00:00 PM#);
|
|
591
|
How can I display only the day of the date
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Day") , "ComputedField", "day(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/11/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/22/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/13/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/14/2004 1:00:00 PM#);
|
|
590
|
How can I display only the month of the date
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Month") , "ComputedField", "month(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/2/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/3/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/4/2004 1:00:00 PM#);
|
|
589
|
How can I get only the year part from a date expression
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Year") , "ComputedField", "year(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/2/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/3/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/4/2004 1:00:00 PM#);
|
|
588
|
Can I convert the expression to date
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date") , "ComputedField", "date(dbl(%0))");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "30000.99");
_ObjectCallMethod( items , "AddItem", "3561.23");
_ObjectCallMethod( items , "AddItem", "1232.34");
|
|
587
|
Can I convert the expression to a number, double or float
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number + 2") , "ComputedField", "dbl(%0)+2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
586
|
How can I display dates in long format
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "LongFormat") , "ComputedField", "longdate(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/2/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/3/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/4/2004 1:00:00 PM#);
|
|
585
|
How can I display dates in short format
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "ShortFormat") , "ComputedField", "shortdate(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/2/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/3/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/4/2004 1:00:00 PM#);
|
|
584
|
How can I display the time only of a date expression
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Time") , "ComputedField", "'time is:' + time(date(%0))");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001 10:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #2/2/2002 11:00:00 AM#);
_ObjectCallMethod( items , "AddItem", #3/3/2003 0:00:00 PM#);
_ObjectCallMethod( items , "AddItem", #4/4/2004 1:00:00 PM#);
|
|
583
|
Is there any function to display currencies, or money formatted as in the control panel
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Currency") , "ComputedField", "currency(dbl(%0))");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
_ObjectCallMethod( items , "AddItem", "10000.99");
|
|
582
|
How can I convert the expression to a string so I can look into the date string expression for month's name
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Str") , "ComputedField", "str(%0) + ' AA'");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
581
|
Can I display the absolute value or positive part of the number
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Abs") , "ComputedField", "abs(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
580
|
Is there any function to get largest number with no fraction part that is not greater than the value
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Floor") , "ComputedField", "floor(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
579
|
Is there any function to round the values base on the .5 value
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Round") , "ComputedField", "round(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
578
|
How can I get or display the integer part of the cell
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Number");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Int") , "ComputedField", "int(%0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "-1.98");
_ObjectCallMethod( items , "AddItem", "0.99");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
|
|
577
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "") , "FormatColumn", "proper(%0)");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "root");
_ObjectCallMethod( items , "InsertItem", h,"","child child");
_ObjectCallMethod( items , "InsertItem", h,"","child child");
_ObjectCallMethod( items , "InsertItem", h,"","child child");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
576
|
Is there any option to display cells in uppercase
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "") , "FormatColumn", "upper(%0)");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","Chld 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
575
|
Is there any option to display cells in lowercase
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "") , "FormatColumn", "lower(%0)");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","Chld 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
574
|
How can I display the column using currency format and enlarge the font for certain values
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Currency");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(17) = 1");
_ObjectSetProperty( column , "FormatColumn", "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "1.23");
_ObjectCallMethod( items , "AddItem", "2.34");
_ObjectCallMethod( items , "AddItem", "9.94");
_ObjectCallMethod( items , "AddItem", "11.94");
_ObjectCallMethod( items , "AddItem", "1000");
|
|
573
|
How can I highlight only parts of the cells
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(17) = 1");
_ObjectSetProperty( column , "FormatColumn", "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","Child 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
572
|
How can I get the number of occurrences of a specified string in the cell
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "");
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "occurrences");
_ObjectSetProperty( column , "ComputedField", "lower(%0) count 'o'");
_ObjectSetProperty( column , "FormatColumn", "'contains ' + value + ' of \'o\' chars'");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1 oooof the root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","Child 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
571
|
How can I display dates in my format
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(17) = 1");
_ObjectSetProperty( column , "FormatColumn", "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/21/2001#);
_ObjectCallMethod( items , "AddItem", #2/22/2002#);
_ObjectCallMethod( items , "AddItem", #3/13/2003#);
_ObjectCallMethod( items , "AddItem", #4/24/2004#);
|
|
570
|
How can I display dates in short format
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date") , "FormatColumn", "shortdate(value)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001#);
_ObjectCallMethod( items , "AddItem", #2/2/2002#);
_ObjectCallMethod( items , "AddItem", #3/3/2003#);
_ObjectCallMethod( items , "AddItem", #4/4/2004#);
|
|
569
|
How can I display dates in long format
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date") , "FormatColumn", "longdate(value)");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", #1/1/2001#);
_ObjectCallMethod( items , "AddItem", #2/2/2002#);
_ObjectCallMethod( items , "AddItem", #3/3/2003#);
_ObjectCallMethod( items , "AddItem", #4/4/2004#);
|
|
568
|
How can I display only the right part of the cell
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "");
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Right");
_ObjectSetProperty( column , "ComputedField", "%0 right 2");
_ObjectSetProperty( column , "FormatColumn", "'^"' + value + '^"'");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","SChild 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
567
|
How can I display only the left part of the cell
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Left") , "ComputedField", "%0 left 2");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod( items , "InsertItem", h,"","SChild 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
566
|
How can I display true or false instead 0 and -1
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Boolean") , "FormatColumn", "value != 0 ? 'true' : 'false'");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", -1);
_ObjectCallMethod( items , "AddItem", 0);
_ObjectCallMethod( items , "AddItem", -1);
_ObjectCallMethod( items , "AddItem", 0);
_ObjectCallMethod( items , "AddItem", 1);
|
|
565
|
How can I save data on XML format
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "LoadXML", "http://www.exontrol.net/testing.xml");
_ObjectCallMethod( grid , "SaveXML", "c:/temp/exgrid.xml");
|
|
564
|
How can I load data on XML format
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "LoadXML", "http://www.exontrol.net/testing.xml");
|
|
563
|
I have an EBN file how can I apply different colors to it, so no need to create a new one
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectSetProperty( grid , "SelBackColor", _ObjectGetProperty( grid , "BackColor"));
_ObjectSetProperty( grid , "SelForeColor", _ObjectGetProperty( grid , "ForeColor"));
_ObjectSetProperty( grid , "HasLines", 0);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Default");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
hC = _ObjectCallMethod( items , "InsertItem", h,"","Default");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,hC")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", hC)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(hC) = 16777216");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(InsertItem(h,,``)) = 6");
hC = _ObjectCallMethod( items , "InsertItem", h,"","Light Green");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,hC")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", hC)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(hC) = 16842496");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(InsertItem(h,,``)) = 6");
hC = _ObjectCallMethod( items , "InsertItem", h,"","Dark Green");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,hC")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", hC)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(hC) = 16809728");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(InsertItem(h,,``)) = 6");
hC = _ObjectCallMethod( items , "InsertItem", h,"","Magenta");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,hC")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", hC)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(hC) = 33521663");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(InsertItem(h,,``)) = 6");
hC = _ObjectCallMethod( items , "InsertItem", h,"","Yellow");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,hC")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", hC)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(hC) = 25165823");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(InsertItem(h,,``)) = 6");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
562
|
How can I change the background color or the visual appearance using ebn for a particular column
OBJECT columns,grid;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
columns = _ObjectGetProperty( grid , "Columns");
_ObjectCallMethod( columns , "Add", "Column 1");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", columns)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Add(`Column 2`).Def(7) = 16777216");
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Add(`Column 3`).Def(7) = 16777471");
_ObjectCallMethod( columns , "Add", "Column 4");
|
|
561
|
How can I change the foreground color for a particular column
OBJECT columns,grid;
grid = ObjectByName("AN1") ;
columns = _ObjectGetProperty( grid , "Columns");
_ObjectCallMethod( columns , "Add", "Column 1");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", columns)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Add(`Column 2`).Def(8) = 8439039");
_ObjectCallMethod( columns , "Add", "Column 3");
|
|
560
|
How can I change the background color for a particular column
OBJECT columns,grid;
grid = ObjectByName("AN1") ;
columns = _ObjectGetProperty( grid , "Columns");
_ObjectCallMethod( columns , "Add", "Column 1");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", columns)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Add(`Column 2`).Def(7) = 8439039");
_ObjectCallMethod( columns , "Add", "Column 3");
|
|
559
|
Does your control support RightToLeft property for RTL languages or right to left
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "BeginUpdate");
_ObjectSetProperty( grid , "ScrollBars", 15);
_ObjectSetProperty( grid , "LinesAtRoot", -1);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "P1");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(0) = True");
_ObjectSetProperty( column , "PartialCheck", -1);
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Root");
_ObjectCallMethod( items , "InsertItem", h,"","Child 1");
_ObjectCallMethod( items , "InsertItem", h,"","Child 2");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
_ObjectSetProperty( grid , "RightToLeft", -1);
_ObjectCallMethod( grid , "EndUpdate");
|
|
558
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
OBJECT columns,grid;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "BeginUpdate");
_ObjectSetProperty( grid , "ScrollBars", 15);
columns = _ObjectGetProperty( grid , "Columns");
_ObjectCallMethod( columns , "Add", "C1");
_ObjectCallMethod( columns , "Add", "C2");
_ObjectCallMethod( columns , "Add", "C3");
_ObjectCallMethod( columns , "Add", "C4");
_ObjectCallMethod( columns , "Add", "C5");
_ObjectCallMethod( columns , "Add", "C6");
_ObjectCallMethod( columns , "Add", "C7");
_ObjectCallMethod( columns , "Add", "C8");
_ObjectSetProperty( grid , "RightToLeft", -1);
_ObjectCallMethod( grid , "EndUpdate");
|
|
557
|
Can I display the cell's check box after the text
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(0) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(34) = `caption,check`");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasCheckBox(AddItem(`Caption 1`),0) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasCheckBox(AddItem(`Caption 2`),0) = True");
|
|
556
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
_ObjectCallMethod(grid, "ExecuteTemplate", "Columns.Add(`Column`).Def(34) = `caption,check,icon,icons,picture`");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Text");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellImage(h,0) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasCheckBox(h,0) = True");
|
|
555
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
_ObjectCallMethod(grid, "ExecuteTemplate", "Columns.Add(`Column`).Def(34) = `caption,icon,check,icons,picture`");
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Text");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellImage(h,0) = 1");
|
|
554
|
How can I display the column's header using multiple lines
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "HeaderHeight", 128);
_ObjectSetProperty( grid , "HeaderSingleLine", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "This is just a column that should break the header.") , "Width", 32);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "This is just another column that should break the header.");
|
|
553
|
How can include the values in the inner cells in the drop down filter window
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -2);
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod(grid, "ExecuteTemplate", "Description(1) = ``");
_ObjectCallMethod(grid, "ExecuteTemplate", "Description(2) = ``");
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Single Column");
_ObjectSetProperty( column , "HTMLCaption", "Single column with <b>inner cells</b>");
_ObjectSetProperty( column , "ToolTip", "Click the drop down filter button, and the filter list includes the inner cells values too.");
_ObjectSetProperty( column , "DisplayFilterButton", -1);
_ObjectSetProperty( column , "DisplayFilterPattern", 0);
_ObjectSetProperty( column , "FilterList", 64);
_ObjectSetProperty( grid , "ShowFocusRect", 0);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
s = _ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.SplitCell(AddItem(`S 1.1`),0)");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,s")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", s)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(,s) = `S 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHAlignment(,s) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellBackColor(,s) = 16777216");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellWidth(,s) = 84");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
s = _ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.SplitCell(AddItem(`S 2.1`),0)");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,s")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", s)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(,s) = `S 2.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHAlignment(,s) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellWidth(,s) = 84");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
s = _ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.SplitCell(AddItem(`S 3.1`),0)");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,s")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", s)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(,s) = `S 3.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHAlignment(,s) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellBackColor(,s) = 16777216");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellWidth(,s) = 84");
|
|
552
|
How can I sort the value gets listed in the drop down filter window
OBJECT column,grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "LinesAtRoot", -1);
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectCallMethod(grid, "ExecuteTemplate", "Description(0) = ``");
_ObjectCallMethod(grid, "ExecuteTemplate", "Description(1) = ``");
_ObjectCallMethod(grid, "ExecuteTemplate", "Description(2) = ``");
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "P1");
_ObjectSetProperty( column , "DisplayFilterButton", -1);
_ObjectSetProperty( column , "DisplayFilterPattern", 0);
_ObjectSetProperty( column , "FilterList", 16);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "P2");
_ObjectSetProperty( column , "DisplayFilterButton", -1);
_ObjectSetProperty( column , "DisplayFilterPattern", 0);
_ObjectSetProperty( column , "FilterList", 32);
items = _ObjectGetProperty( grid , "Items");
h = _ObjectCallMethod( items , "AddItem", "Z3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h,1) = `C`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(InsertItem(h,,`Z1`),1) = `B`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(InsertItem(h,,`Z2`),1) = `A`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandItem(h) = True");
|
|
551
|
How can I align the text/caption on the scroll bar
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectCallMethod(grid, "ExecuteTemplate", "ScrollPartCaption(1,512) = `left`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ScrollPartCaptionAlignment(1,512) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "ScrollPartCaption(1,128) = `right`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ScrollPartCaptionAlignment(1,128) = 2");
_ObjectSetProperty( grid , "ColumnAutoResize", 0);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 2);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 3);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 4);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 5);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 6);
|
|
550
|
How do I select the next row/item
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", "Item 1");
_ObjectCallMethod( items , "AddItem", "Item 2");
_ObjectCallMethod( items , "AddItem", "Item 3");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.SelectItem(NextVisibleItem(FocusItem)) = True");
|
|
549
|
How do I enable resizing ( changing the height ) the items at runtime
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "DrawGridLines", 1);
_ObjectSetProperty( grid , "ScrollBySingleLine", -1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "Item 1");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(AddItem(`Item 2`)) = 48");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "Item 3");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "Item 4");
|
|
548
|
How do I enable resizing all the items at runtime
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "ItemsAllowSizing", 1);
_ObjectSetProperty( grid , "DrawGridLines", 1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "Item 1");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(AddItem(`Item 2`)) = 48");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "Item 3");
|
|
547
|
How can I remove the filter
OBJECT column,grid;
grid = ObjectByName("AN1") ;
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column");
_ObjectSetProperty( column , "DisplayFilterButton", -1);
_ObjectSetProperty( column , "FilterType", 1);
_ObjectCallMethod( grid , "ApplyFilter");
_ObjectCallMethod( grid , "ClearFilter");
|
|
546
|
How can I vertically display the column's caption, in the header
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "A") , "HeaderVertical", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "B") , "HeaderVertical", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "H") , "HeaderVertical", 0);
|
|
545
|
When I have a column in a grid that is set to having a checkbox, and the grid's singlesel is set to false, I am able to toggle the checkboxes for a while, but lose this functionality eventually. Do you have a tip
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod(grid, "ExecuteTemplate", "Columns.Add(`Check`).Def(0) = True");
_ObjectSetProperty( grid , "SingleSel", 0);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", -1);
_ObjectCallMethod( items , "AddItem", 0);
_ObjectCallMethod( items , "AddItem", 0);
|
|
544
|
How do I arrange, format or layout the item on multiple levels or lines, as a subform
OBJECT columns,editor,grid,items,var_column,var_column1,var_column2,var_column3,var_column4,var_column5,var_column6,var_editor;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
_ObjectSetProperty( grid , "DrawGridLines", -2);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "ScrollBySingleLine", -1);
_ObjectSetProperty( grid , "BackColor", 16777215);
_ObjectSetProperty( grid , "SelBackColor", 16777215);
_ObjectSetProperty( grid , "SelForeColor", 2147483666);
columns = _ObjectGetProperty( grid , "Columns");
_ObjectCallMethod( columns , "Add", "");
var_Column = _ObjectCallMethod( columns , "Add", "Column");
var_column = var_Column;
_ObjectSetProperty( var_column , "Visible", 0);
_ObjectSetProperty( _ObjectGetProperty( var_column , "Editor") , "EditType", 1);
var_Column1 = _ObjectCallMethod( columns , "Add", "Column");
var_column1 = var_Column1;
_ObjectSetProperty( var_column1 , "Visible", 0);
_ObjectSetProperty( _ObjectGetProperty( var_column1 , "Editor") , "EditType", 2);
var_Column2 = _ObjectCallMethod( columns , "Add", "Column");
var_column2 = var_Column2;
_ObjectSetProperty( var_column2 , "Visible", 0);
_ObjectSetProperty( _ObjectGetProperty( var_column2 , "Editor") , "EditType", 2);
var_Column3 = _ObjectCallMethod( columns , "Add", "Column");
var_column3 = var_Column3;
_ObjectSetProperty( var_column3 , "Visible", 0);
editor = _ObjectGetProperty( var_column3 , "Editor");
_ObjectSetProperty( editor , "EditType", 19);
_ObjectCallMethod(grid, "TemplatePut", "Dim ediObj")
_ObjectCallMethod(grid, "TemplatePut", editor)
_ObjectCallMethod(grid, "ExecuteTemplate", "ediObj.Option(17) = 1");
var_Column4 = _ObjectCallMethod( columns , "Add", "Column");
var_column4 = var_Column4;
_ObjectSetProperty( var_column4 , "Visible", 0);
_ObjectSetProperty( _ObjectGetProperty( var_column4 , "Editor") , "EditType", 7);
_ObjectSetProperty( _ObjectCallMethod( columns , "Add", "Column") , "Visible", 0);
var_Column5 = _ObjectCallMethod( columns , "Add", "Column");
var_column5 = var_Column5;
_ObjectSetProperty( var_column5 , "Visible", 0);
_ObjectSetProperty( _ObjectGetProperty( var_column5 , "Editor") , "EditType", 2);
var_Column6 = _ObjectCallMethod( columns , "Add", "Column");
var_column6 = var_Column6;
_ObjectSetProperty( var_column6 , "Visible", 0);
_ObjectCallMethod(grid, "TemplatePut", "Dim varObj")
_ObjectCallMethod(grid, "TemplatePut", var_column6)
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Def(16) = 0");
var_Editor = _ObjectGetProperty( var_column6 , "Editor");
var_editor = var_Editor;
_ObjectSetProperty( var_editor , "EditType", 5);
_ObjectSetProperty( var_editor , "ButtonWidth", 17);
_ObjectCallMethod(grid, "TemplatePut", "Dim varObj")
_ObjectCallMethod(grid, "TemplatePut", var_editor)
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(23) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(25) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(24) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(20) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(3) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(2) = -1");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(27) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(26) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(21) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "varObj.Option(22) = 0");
_ObjectSetProperty( var_column6 , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( columns , "Add", "Column") , "Visible", 0);
items = _ObjectGetProperty( grid , "Items");
h0 = _ObjectCallMethod( items , "AddItem", "");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h0")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h0)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,9) = `Dismiss`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellFormatLevel(h0,0) = `12;^" ^"[b=0][bg=RGB(248,248,248)]/(^" ^"[b=0][bg=RGB(248,248,248)]:12,(1;^" ^"[b=0]/(^" ^"[b=0]:1,(25;(5;^" ^"[b=0]/((^"Subject:^"[b=0]:80,(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,(^" ^"[b=0][bg=RGB(255,0,0)]:5,1[b=0]),^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]))/1;^" ^"[b=0]))/20;(^"Location:^"[b=0]:80,(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,2[b=0],^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]),((^" ^"[b=0]:10,^"Label:^"[b=0])):50,(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,3[b=0],^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]))/50;(10;^" ^"[b=0]/(1;^" ^"[b=0][bg=RGB(255,0,0)]/(^"Recurrence:^"[b=0]:80,^"Occurs every day effective 20/04/2007 from 01:00 to 01:01.^"[b=0])/1;^" ^"[b=0][bg=RGB(255,0,0)])/10;^" ^"[b=0])/23;(4[b=0]:20,^"Reminder:^"[b=0]:60,(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,5[b=0],^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]),((^" ^"[b=0]:5,6[b=0])):30,((^" ^"[b=0]:10,^"Show time as:^"[b=0])):90,(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,7[b=0],^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]))/(12;^" ^"[b=0]/(1;^" ^"[b=0][bg=RGB(0,0,0)]/(^" ^"[b=0][bg=RGB(0,0,0)]:1,8[b=0],^" ^"[b=0][bg=RGB(0,0,0)]:1)/1;^" ^"[b=0][bg=RGB(0,0,0)]))/35;(5;^" ^"[b=0]/(^" ^"[b=0],^" ^"[b=0],((^" ^"[b=0]:40,9[b=0])))/5;^" ^"[b=0])),^" ^"[b=0]:1)/1;^" ^"[b=0]),^" ^"[b=0][bg=RGB(248,248,248)]:12)/12;^" ^"[b=0][bg=RGB(248,248,248)]`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasCheckBox(h0,4) = -1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasButton(h0,9) = -1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHAlignment(h0,9) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellVAlignment(h0,8) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellForeColor(h0,8) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHasButton(h0,6) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,6) = `<img>1</img>`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValueFormat(h0,6) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellHAlignment(h0,6) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemHeight(h0) = 296");
|
|
543
|
How do I arrange, format or layout the item on multiple levels or lines
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "DefaultItemHeight", 34);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 1) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 2) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 3) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 4) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 5) , "Visible", 0);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General");
items = _ObjectGetProperty( grid , "Items");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 0));
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 2");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,3) = 3");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,4) = 4");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellFormatLevel(DefaultItem,5) = `0,1,2/3,4`");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 5));
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 6");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 7");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,3) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,4) = 9");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellFormatLevel(DefaultItem,5) = `3,4/0,1,2`");
|
|
542
|
How do I arrange, format or layout the column's header on multiple levels or lines
OBJECT grid;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 1) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 2) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 3) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 4) , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", 5) , "Visible", 0);
_ObjectSetProperty( grid , "HeaderHeight", 32);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General") , "FormatLevel", "0,1,2/3,4");
|
|
541
|
How do I arrange, format or layout the item on multiple levels or lines
OBJECT column,editor,grid,items,var_column,var_column1,var_column2;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "DefaultItemHeight", 53);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "EmployeeID") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "LastName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "FirstName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Handler") , "Visible", 0);
var_Column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Title");
var_column = var_Column;
_ObjectSetProperty( var_column , "Visible", 0);
_ObjectSetProperty( var_column , "DisplayFilterButton", -1);
var_Column1 = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "TitleOfCourtesy");
var_column1 = var_Column1;
_ObjectSetProperty( var_column1 , "Visible", 0);
_ObjectSetProperty( var_column1 , "DisplayFilterButton", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "BirthDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HideDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Address") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "City") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Region") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "PostCode") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Country") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HomePage") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Extension") , "Visible", 0);
var_Column2 = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Photo");
var_column2 = var_Column2;
_ObjectSetProperty( var_column2 , "Visible", 0);
editor = _ObjectGetProperty( var_column2 , "Editor");
_ObjectSetProperty( editor , "DropDownVisible", 0);
_ObjectSetProperty( editor , "EditType", 11);
_ObjectCallMethod(grid, "TemplatePut", "Dim ediObj")
_ObjectCallMethod(grid, "TemplatePut", editor)
_ObjectCallMethod(grid, "ExecuteTemplate", "ediObj.Option(52) = 0");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Notes") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "ReportsTo") , "Visible", 0);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Personal Info");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `15:54,(2/1/4)`");
_ObjectSetProperty( column , "FormatLevel", "18;18/(15:54,(2/1/4))");
_ObjectSetProperty( column , "Width", 196);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General Info");
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `(8/18;5):128,((((13/11/12),(6/7/10)),16))`");
_ObjectSetProperty( column , "FormatLevel", "18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
_ObjectSetProperty( column , "Width", 512);
items = _ObjectGetProperty( grid , "Items");
h0 = _ObjectCallMethod( items , "AddItem", 1);
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h0")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h0)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,1) = `Davolio`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,2) = `Nancy`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,3) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,4) = `Sales Representative`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,5) = `Ms.`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,6) = `12/8/1948`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,7) = `5/1/1992`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,8) = `507-20th Ave. \r\nE.Apt. 2A`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,9) = `Seattle`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,10) = `WA`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,11) = `98122`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,12) = `USA`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,13) = `(206) 555-9857`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,14) = `5467`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,15) = Me.ExecuteTemplate(`loadpicture(`c:\exontrol\images\sample.bmp`)`)");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,16) = `Education includes a BA in psychology from Colorado State University in 1970. She also completed ^"The Art of the Cold Call.^" Nancy is a member of ToastmastersInternational.`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,17) = 2");
_ObjectCallMethod( grid , "PutItems", _ObjectCallMethod( grid , "GetItems", 0));
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellFormatLevel(FocusItem,`General Info`) = `15,10,4`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellFormatLevel(FocusItem,`Personal Info`) = `1/2`");
|
|
540
|
How do I arrange, format or layout the data on multiple levels or lines
OBJECT column,editor,grid,items,var_column,var_column1,var_column2;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "DefaultItemHeight", 53);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "EmployeeID") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "LastName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "FirstName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Handler") , "Visible", 0);
var_Column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Title");
var_column = var_Column;
_ObjectSetProperty( var_column , "Visible", 0);
_ObjectSetProperty( var_column , "DisplayFilterButton", -1);
var_Column1 = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "TitleOfCourtesy");
var_column1 = var_Column1;
_ObjectSetProperty( var_column1 , "Visible", 0);
_ObjectSetProperty( var_column1 , "DisplayFilterButton", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "BirthDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HideDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Address") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "City") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Region") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "PostCode") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Country") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HomePage") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Extension") , "Visible", 0);
var_Column2 = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Photo");
var_column2 = var_Column2;
_ObjectSetProperty( var_column2 , "Visible", 0);
editor = _ObjectGetProperty( var_column2 , "Editor");
_ObjectSetProperty( editor , "DropDownVisible", 0);
_ObjectSetProperty( editor , "EditType", 11);
_ObjectCallMethod(grid, "TemplatePut", "Dim ediObj")
_ObjectCallMethod(grid, "TemplatePut", editor)
_ObjectCallMethod(grid, "ExecuteTemplate", "ediObj.Option(52) = 0");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Notes") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "ReportsTo") , "Visible", 0);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Personal Info");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `15:54,(2/1/4)`");
_ObjectSetProperty( column , "FormatLevel", "18;18/(15:54,(2/1/4))");
_ObjectSetProperty( column , "Width", 196);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General Info");
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `(8/18;5):128,((((13/11/12),(6/7/10)),16))`");
_ObjectSetProperty( column , "FormatLevel", "18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
_ObjectSetProperty( column , "Width", 512);
items = _ObjectGetProperty( grid , "Items");
h0 = _ObjectCallMethod( items , "AddItem", 1);
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj,h0")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "TemplatePut", h0)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,1) = `Davolio`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,2) = `Nancy`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,3) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,4) = `Sales Representative`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,5) = `Ms.`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,6) = `12/8/1948`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,7) = `5/1/1992`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,8) = `507-20th Ave. \r\nE.Apt. 2A`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,9) = `Seattle`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,10) = `WA`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,11) = `98122`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,12) = `USA`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,13) = `(206) 555-9857`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,14) = `5467`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,15) = Me.ExecuteTemplate(`loadpicture(`c:\exontrol\images\sample.bmp`)`)");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,16) = `Education includes a BA in psychology from Colorado State University in 1970. She also completed ^"The Art of the Cold Call.^" Nancy is a member of ToastmastersInternational.`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(h0,17) = 2");
_ObjectCallMethod( grid , "PutItems", _ObjectCallMethod( grid , "GetItems", 0));
_ObjectCallMethod( grid , "PutItems", _ObjectCallMethod( grid , "GetItems", 0));
_ObjectCallMethod( grid , "PutItems", _ObjectCallMethod( grid , "GetItems", 0));
|
|
539
|
How do I arrange, format or layout the column's data on multiple levels or lines
OBJECT column,grid,var_column,var_column1;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "DefaultItemHeight", 68);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "EmployeeID") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "LastName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "FirstName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Handler") , "Visible", 0);
var_Column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Title");
var_column = var_Column;
_ObjectSetProperty( var_column , "Visible", 0);
_ObjectSetProperty( var_column , "DisplayFilterButton", -1);
var_Column1 = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "TitleOfCourtesy");
var_column1 = var_Column1;
_ObjectSetProperty( var_column1 , "Visible", 0);
_ObjectSetProperty( var_column1 , "DisplayFilterButton", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "BirthDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HideDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Address") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "City") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Region") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "PostCode") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Country") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HomePage") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Extension") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Photo") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Notes") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "ReportsTo") , "Visible", 0);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Personal Info");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `18;18/(15:54,(2/1/4))`");
_ObjectSetProperty( column , "FormatLevel", "18;18/(15:54,(2/1/4))");
_ObjectSetProperty( column , "Width", 196);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General Info");
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(32) = `18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))`");
_ObjectSetProperty( column , "FormatLevel", "18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
_ObjectSetProperty( column , "Width", 512);
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "AddItem", "");
|
|
538
|
How do I arrange, format or layout the column's header on multiple levels or lines
OBJECT column,grid;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "EmployeeID") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "LastName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "FirstName") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Handler") , "Visible", 0);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Title");
_ObjectSetProperty( column , "Visible", 0);
_ObjectSetProperty( column , "DisplayFilterButton", -1);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "TitleOfCourtesy");
_ObjectSetProperty( column , "Visible", 0);
_ObjectSetProperty( column , "DisplayFilterButton", -1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "BirthDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HideDate") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Address") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "City") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Region") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "PostCode") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Country") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "HomePage") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Extension") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Photo") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Notes") , "Visible", 0);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "ReportsTo") , "Visible", 0);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Personal Info");
_ObjectSetProperty( column , "FormatLevel", "18;18/(15:54,(2/1/4))");
_ObjectSetProperty( column , "Width", 196);
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "General Info");
_ObjectSetProperty( column , "FormatLevel", "18;19/((8/18;5):128,((((13/11/12),(6/7/10)),16)))");
_ObjectSetProperty( column , "Width", 512);
|
|
537
|
How can I select a cells like in excel
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "SingleSel", 0);
_ObjectSetProperty( grid , "FullRowSelect", 1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column1") , "Selected", -1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column2");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column3") , "Selected", -1);
items = _ObjectGetProperty( grid , "Items");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 0));
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 2");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 3));
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 4");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 5");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 6));
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 7");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 8");
|
|
536
|
How can I select a multiple column
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "SingleSel", 0);
_ObjectSetProperty( grid , "FullRowSelect", 1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column1") , "Selected", -1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column2");
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column3") , "Selected", -1);
items = _ObjectGetProperty( grid , "Items");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 0));
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 1");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 2");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 3));
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 4");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 5");
_ObjectSetProperty( items , "DefaultItem", _ObjectCallMethod( items , "AddItem", 6));
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,1) = 7");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(0,2) = 8");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "SelectAll");
|
|
535
|
How can I select a column
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "MarkSearchColumn", 0);
_ObjectSetProperty( grid , "SingleSel", 0);
_ObjectSetProperty( grid , "FullRowSelect", 1);
_ObjectSetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column1") , "Selected", -1);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`One`),1) = `One`");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Two`),1) = `Two`");
_ObjectCallMethod( _ObjectGetProperty( grid , "Items") , "SelectAll");
|
|
534
|
How can I collapse all cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 64");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Expanded`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod( items , "CollapseAllCards");
|
|
533
|
How can I expand all cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 64");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Expanded`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod( items , "ExpandAllCards");
|
|
532
|
How can I expand or collapse a card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 64");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Expanded`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
531
|
How can I format or arrange the data being displayed in the card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "HasButtons", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,5) = `(^"Title:^",0),1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = ``");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,2) = 164");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 18");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
530
|
How can I format or arrange the data being displayed in the card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `(^"ABC^",2)/(0,3,^"DEFGH^")/1/0/1/0/1/1,0[bg=RGB(230,230,230)][fg=RGB(255,0,0)`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,5) = ``");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
529
|
How can I hide the tilte for the cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `0/1/0/1/0/1/0/1,0`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,5) = ``");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
528
|
How can I display resizing lines between cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,14) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,15) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,9) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,10) = 8");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
527
|
How can edit the text in the card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 64");
_ObjectSetProperty( _ObjectGetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1") , "Editor") , "EditType", 1);
_ObjectSetProperty( _ObjectGetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2") , "Editor") , "EditType", 1);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
526
|
How can I change the height of the card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 64");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
525
|
How can I display the cards from top to bottom
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,11) = False");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
524
|
How do I change the background color for a specified card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemForeColor(FocusItem) = 255");
|
|
523
|
How do I change the visual aspect for a specified card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(FocusItem) = 16777216");
|
|
522
|
How do I change the background color for a specified card
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ItemBackColor(FocusItem) = 255");
|
|
521
|
Is there any way to specify the foreground color for the title of the cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,7) = 255");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
520
|
Is there any way to specify the foreground color for all cards, including its title
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "ForeColor", 255);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
519
|
How can I change the visual appearance for all cards, including the title
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 1,"c:\exontrol\images\normal.ebn");
_ObjectCallMethod( _ObjectGetProperty( grid , "VisualAppearance") , "Add", 2,"c:\exontrol\images\pushed.ebn");
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,8) = 16777216");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,6) = 33554432");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
518
|
Is there any way to specify the background color for all cards, including its title
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,8) = 255");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,6) = 128");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
517
|
Is there any way to specify the background color for all cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,8) = 255");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
516
|
How can I specify the distance between cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,9) = 16");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,10) = 16");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
515
|
How can I resize the cards at runtime
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ItemsAllowSizing", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,14) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,15) = True");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,9) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,10) = 8");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.ExpandCard(FocusItem) = True");
|
|
514
|
How can show the grid lines for my cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
513
|
How can I hide the +/- expanding / collapsing buttons in the cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "ExpandOnDblClick", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
512
|
How can I hide the +/- expanding / collapsing buttons in the cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "HasButtons", 0);
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
511
|
Is there any way to to specify the number of cards being displayed from letf to right
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,12) = 3");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
510
|
Is there any way to to specify the width of the cards, so they fit the control's client area
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,2) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,12) = 2");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
509
|
Is there any way to to specify the width of the cards, so they fit the control's client area
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,2) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
508
|
Is there any way to to specify the width of the cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,2) = 64");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
507
|
Is there any way to indent the control's data relative to the borders or the frame of the control
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "HeaderVisible", 0);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,0) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,1) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
506
|
Is there any way to indent the control's data relative to the borders or the frame of the control
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "ViewMode", 0);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(0,0) = 8");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(0,1) = 8");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 1`),1) = `Item 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 2`),1) = `Item 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 3`),1) = `Item 1.3`");
|
|
505
|
How can I display my rows or items as a table
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "ViewMode", 0);
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 1`),1) = `Item 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 2`),1) = `Item 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Item 3`),1) = `Item 1.3`");
|
|
504
|
How can I display my rows as cards
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectSetProperty( grid , "DrawGridLines", -1);
_ObjectSetProperty( grid , "ViewMode", 1);
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,4) = `1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "ViewModeOption(1,3) = 36");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 1");
_ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Column 2");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 1`),1) = `Card 1.1`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 2`),1) = `Card 1.2`");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(`Card 3`),1) = `Card 1.3`");
|
|
503
|
How can I avoid focusing a new cell, when user presses an arrow, page, home or end key, while the editor is opened
OBJECT grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(20) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(21) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(22) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(23) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(24) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(25) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(26) = 0");
_ObjectCallMethod(grid, "ExecuteTemplate", "DefaultEditorOption(27) = 0");
_ObjectSetProperty( _ObjectGetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Edit") , "Editor") , "EditType", 1);
_ObjectSetProperty( _ObjectGetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Edit") , "Editor") , "EditType", 1);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "TemplatePut", "Dim iteObj")
_ObjectCallMethod(grid, "TemplatePut", items)
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(0),1) = 1");
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod(grid, "ExecuteTemplate", "iteObj.CellValue(AddItem(2),1) = 3");
|
|
502
|
How can I expand predefined items in a drop down list editor as I type
OBJECT column,editor,grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
column = _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "DropDown");
_ObjectCallMethod(grid, "TemplatePut", "Dim colObj")
_ObjectCallMethod(grid, "TemplatePut", column)
_ObjectCallMethod(grid, "ExecuteTemplate", "colObj.Def(17) = 1");
editor = _ObjectGetProperty( column , "Editor");
_ObjectCallMethod(grid, "TemplatePut", "Dim ediObj")
_ObjectCallMethod(grid, "TemplatePut", editor)
_ObjectCallMethod(grid, "ExecuteTemplate", "ediObj.Option(38) = True");
_ObjectSetProperty( editor , "EditType", 3);
_ObjectSetProperty( editor , "DropDownAutoWidth", 0);
_ObjectCallMethod( editor , "AddItem", 1,"<b>CObject</b> class",1);
_ObjectCallMethod( editor , "InsertItem", 2,"<b>CCmdTarget</b> class",2,1);
_ObjectCallMethod( editor , "InsertItem", 3,"<b>CWnd</b> class",3,2);
_ObjectCallMethod( editor , "InsertItem", 6,"<bgcolor=10A0E0><fgcolor=F0F0F0>S y n c</fgcolor>",1,1);
_ObjectCallMethod( editor , "AddItem", 4,"Exceptions",1);
_ObjectCallMethod( editor , "InsertItem", 7,"<b>System</b> Exceptions",2,4);
_ObjectCallMethod( editor , "AddItem", 5,"File Services",2);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", 1);
_ObjectCallMethod( items , "AddItem", 2);
|
|
501
|
How can I add an extra button to a date picker editor
OBJECT editor,grid,items;
grid = ObjectByName("AN1") ;
_ObjectCallMethod( grid , "Images", "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
_ObjectSetProperty( grid , "DefaultItemHeight", 20);
editor = _ObjectGetProperty( _ObjectCallMethod( _ObjectGetProperty( grid , "Columns") , "Add", "Date") , "Editor");
_ObjectSetProperty( editor , "EditType", 7);
_ObjectCallMethod( editor , "AddButton", "B1",2,1,"This is a bit of text that's shown when the cursor hovers the button B1");
_ObjectSetProperty( editor , "ButtonWidth", 20);
items = _ObjectGetProperty( grid , "Items");
_ObjectCallMethod( items , "AddItem", 0);
_ObjectCallMethod( items , "AddItem", 1);
|